Combine Two Tables
문제


코드
Oracle
SELECT firstName, lastName, city, state
FROM PERSON
LEFT JOIN ADDRESS ON PERSON.PERSONID = ADDRESS.PERSONID
수행 결과



SELECT firstName, lastName, city, state
FROM PERSON
LEFT JOIN ADDRESS ON PERSON.PERSONID = ADDRESS.PERSONID
